When you modify parts of a graph programmatically, such as the legend or one of the axes, you specify which part of the graph to modify using the partType and partSpecifics parameters.
Some of the major parts of a graph are labelled in the following illustration:
The following are the codes for the partType parameter:
Code
Graph Part
1
Plot rectangle
2
Legend
3
Axis
4
Label
5
Title
6
Major gridlines
7
Minor gridlines
8
Series
9
Value labels for series
The following are the codes for the partSpecifics parameter:
Graph Part
Specific Part Code
Plot rectangle
For 2D graphs: 0 = Entire rectangle,
For 3D graphs: 1 = Back, 2 = Side, 3 = Bottom
Legend
0 = Legend rectangle
Axis
0 = Category, 1 = Series, 2 = Values
Labels
0 = Category, 1 = Series, 2 = Values
Titles
0 = Category, 1 = Series, 2 = Values
Major gridlines
0 = Category, 1 = Series, 2 = Values
Minor gridlines
0 = Category, 1 = Series, 2 = Values
Series/Value labels
(Series number * 100) + (Side number) for series
Side numbers (for sides of series)
0 = All sides (also use for all 2D graphs),1 = Front, 2 = Left, 3 = Right, 4 = Top, 5 = Bottom
Note: Series in 2D graphs have one side (Front); series in 3D graphs can display up to three sides at a time.